package org.flower.bean;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CommodityDetailsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CommodityDetailsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andComnameIsNull() {
            addCriterion("ComName is null");
            return (Criteria) this;
        }

        public Criteria andComnameIsNotNull() {
            addCriterion("ComName is not null");
            return (Criteria) this;
        }

        public Criteria andComnameEqualTo(String value) {
            addCriterion("ComName =", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotEqualTo(String value) {
            addCriterion("ComName <>", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameGreaterThan(String value) {
            addCriterion("ComName >", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameGreaterThanOrEqualTo(String value) {
            addCriterion("ComName >=", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameLessThan(String value) {
            addCriterion("ComName <", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameLessThanOrEqualTo(String value) {
            addCriterion("ComName <=", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameLike(String value) {
            addCriterion("ComName like", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotLike(String value) {
            addCriterion("ComName not like", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameIn(List<String> values) {
            addCriterion("ComName in", values, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotIn(List<String> values) {
            addCriterion("ComName not in", values, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameBetween(String value1, String value2) {
            addCriterion("ComName between", value1, value2, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotBetween(String value1, String value2) {
            addCriterion("ComName not between", value1, value2, "comname");
            return (Criteria) this;
        }

        public Criteria andContentIsNull() {
            addCriterion("Content is null");
            return (Criteria) this;
        }

        public Criteria andContentIsNotNull() {
            addCriterion("Content is not null");
            return (Criteria) this;
        }

        public Criteria andContentEqualTo(String value) {
            addCriterion("Content =", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotEqualTo(String value) {
            addCriterion("Content <>", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentGreaterThan(String value) {
            addCriterion("Content >", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentGreaterThanOrEqualTo(String value) {
            addCriterion("Content >=", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentLessThan(String value) {
            addCriterion("Content <", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentLessThanOrEqualTo(String value) {
            addCriterion("Content <=", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentLike(String value) {
            addCriterion("Content like", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotLike(String value) {
            addCriterion("Content not like", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentIn(List<String> values) {
            addCriterion("Content in", values, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotIn(List<String> values) {
            addCriterion("Content not in", values, "content");
            return (Criteria) this;
        }

        public Criteria andContentBetween(String value1, String value2) {
            addCriterion("Content between", value1, value2, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotBetween(String value1, String value2) {
            addCriterion("Content not between", value1, value2, "content");
            return (Criteria) this;
        }

        public Criteria andOutnumIsNull() {
            addCriterion("outNum is null");
            return (Criteria) this;
        }

        public Criteria andOutnumIsNotNull() {
            addCriterion("outNum is not null");
            return (Criteria) this;
        }

        public Criteria andOutnumEqualTo(Integer value) {
            addCriterion("outNum =", value, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumNotEqualTo(Integer value) {
            addCriterion("outNum <>", value, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumGreaterThan(Integer value) {
            addCriterion("outNum >", value, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumGreaterThanOrEqualTo(Integer value) {
            addCriterion("outNum >=", value, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumLessThan(Integer value) {
            addCriterion("outNum <", value, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumLessThanOrEqualTo(Integer value) {
            addCriterion("outNum <=", value, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumIn(List<Integer> values) {
            addCriterion("outNum in", values, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumNotIn(List<Integer> values) {
            addCriterion("outNum not in", values, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumBetween(Integer value1, Integer value2) {
            addCriterion("outNum between", value1, value2, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutnumNotBetween(Integer value1, Integer value2) {
            addCriterion("outNum not between", value1, value2, "outnum");
            return (Criteria) this;
        }

        public Criteria andOutpriceIsNull() {
            addCriterion("outPrice is null");
            return (Criteria) this;
        }

        public Criteria andOutpriceIsNotNull() {
            addCriterion("outPrice is not null");
            return (Criteria) this;
        }

        public Criteria andOutpriceEqualTo(Double value) {
            addCriterion("outPrice =", value, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceNotEqualTo(Double value) {
            addCriterion("outPrice <>", value, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceGreaterThan(Double value) {
            addCriterion("outPrice >", value, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("outPrice >=", value, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceLessThan(Double value) {
            addCriterion("outPrice <", value, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceLessThanOrEqualTo(Double value) {
            addCriterion("outPrice <=", value, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceIn(List<Double> values) {
            addCriterion("outPrice in", values, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceNotIn(List<Double> values) {
            addCriterion("outPrice not in", values, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceBetween(Double value1, Double value2) {
            addCriterion("outPrice between", value1, value2, "outprice");
            return (Criteria) this;
        }

        public Criteria andOutpriceNotBetween(Double value1, Double value2) {
            addCriterion("outPrice not between", value1, value2, "outprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceIsNull() {
            addCriterion("marketPrice is null");
            return (Criteria) this;
        }

        public Criteria andMarketpriceIsNotNull() {
            addCriterion("marketPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMarketpriceEqualTo(Double value) {
            addCriterion("marketPrice =", value, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceNotEqualTo(Double value) {
            addCriterion("marketPrice <>", value, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceGreaterThan(Double value) {
            addCriterion("marketPrice >", value, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("marketPrice >=", value, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceLessThan(Double value) {
            addCriterion("marketPrice <", value, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceLessThanOrEqualTo(Double value) {
            addCriterion("marketPrice <=", value, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceIn(List<Double> values) {
            addCriterion("marketPrice in", values, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceNotIn(List<Double> values) {
            addCriterion("marketPrice not in", values, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceBetween(Double value1, Double value2) {
            addCriterion("marketPrice between", value1, value2, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMarketpriceNotBetween(Double value1, Double value2) {
            addCriterion("marketPrice not between", value1, value2, "marketprice");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceIsNull() {
            addCriterion("MaterialScience is null");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceIsNotNull() {
            addCriterion("MaterialScience is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceEqualTo(String value) {
            addCriterion("MaterialScience =", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceNotEqualTo(String value) {
            addCriterion("MaterialScience <>", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceGreaterThan(String value) {
            addCriterion("MaterialScience >", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceGreaterThanOrEqualTo(String value) {
            addCriterion("MaterialScience >=", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceLessThan(String value) {
            addCriterion("MaterialScience <", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceLessThanOrEqualTo(String value) {
            addCriterion("MaterialScience <=", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceLike(String value) {
            addCriterion("MaterialScience like", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceNotLike(String value) {
            addCriterion("MaterialScience not like", value, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceIn(List<String> values) {
            addCriterion("MaterialScience in", values, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceNotIn(List<String> values) {
            addCriterion("MaterialScience not in", values, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceBetween(String value1, String value2) {
            addCriterion("MaterialScience between", value1, value2, "materialscience");
            return (Criteria) this;
        }

        public Criteria andMaterialscienceNotBetween(String value1, String value2) {
            addCriterion("MaterialScience not between", value1, value2, "materialscience");
            return (Criteria) this;
        }

        public Criteria andPackingIsNull() {
            addCriterion("packing is null");
            return (Criteria) this;
        }

        public Criteria andPackingIsNotNull() {
            addCriterion("packing is not null");
            return (Criteria) this;
        }

        public Criteria andPackingEqualTo(String value) {
            addCriterion("packing =", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotEqualTo(String value) {
            addCriterion("packing <>", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingGreaterThan(String value) {
            addCriterion("packing >", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingGreaterThanOrEqualTo(String value) {
            addCriterion("packing >=", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingLessThan(String value) {
            addCriterion("packing <", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingLessThanOrEqualTo(String value) {
            addCriterion("packing <=", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingLike(String value) {
            addCriterion("packing like", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotLike(String value) {
            addCriterion("packing not like", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingIn(List<String> values) {
            addCriterion("packing in", values, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotIn(List<String> values) {
            addCriterion("packing not in", values, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingBetween(String value1, String value2) {
            addCriterion("packing between", value1, value2, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotBetween(String value1, String value2) {
            addCriterion("packing not between", value1, value2, "packing");
            return (Criteria) this;
        }

        public Criteria andDistributionIsNull() {
            addCriterion("Distribution is null");
            return (Criteria) this;
        }

        public Criteria andDistributionIsNotNull() {
            addCriterion("Distribution is not null");
            return (Criteria) this;
        }

        public Criteria andDistributionEqualTo(String value) {
            addCriterion("Distribution =", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionNotEqualTo(String value) {
            addCriterion("Distribution <>", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionGreaterThan(String value) {
            addCriterion("Distribution >", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionGreaterThanOrEqualTo(String value) {
            addCriterion("Distribution >=", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionLessThan(String value) {
            addCriterion("Distribution <", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionLessThanOrEqualTo(String value) {
            addCriterion("Distribution <=", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionLike(String value) {
            addCriterion("Distribution like", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionNotLike(String value) {
            addCriterion("Distribution not like", value, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionIn(List<String> values) {
            addCriterion("Distribution in", values, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionNotIn(List<String> values) {
            addCriterion("Distribution not in", values, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionBetween(String value1, String value2) {
            addCriterion("Distribution between", value1, value2, "distribution");
            return (Criteria) this;
        }

        public Criteria andDistributionNotBetween(String value1, String value2) {
            addCriterion("Distribution not between", value1, value2, "distribution");
            return (Criteria) this;
        }

        public Criteria andComimageIsNull() {
            addCriterion("comImage is null");
            return (Criteria) this;
        }

        public Criteria andComimageIsNotNull() {
            addCriterion("comImage is not null");
            return (Criteria) this;
        }

        public Criteria andComimageEqualTo(String value) {
            addCriterion("comImage =", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageNotEqualTo(String value) {
            addCriterion("comImage <>", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageGreaterThan(String value) {
            addCriterion("comImage >", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageGreaterThanOrEqualTo(String value) {
            addCriterion("comImage >=", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageLessThan(String value) {
            addCriterion("comImage <", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageLessThanOrEqualTo(String value) {
            addCriterion("comImage <=", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageLike(String value) {
            addCriterion("comImage like", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageNotLike(String value) {
            addCriterion("comImage not like", value, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageIn(List<String> values) {
            addCriterion("comImage in", values, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageNotIn(List<String> values) {
            addCriterion("comImage not in", values, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageBetween(String value1, String value2) {
            addCriterion("comImage between", value1, value2, "comimage");
            return (Criteria) this;
        }

        public Criteria andComimageNotBetween(String value1, String value2) {
            addCriterion("comImage not between", value1, value2, "comimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageIsNull() {
            addCriterion("detailsImage is null");
            return (Criteria) this;
        }

        public Criteria andDetailsimageIsNotNull() {
            addCriterion("detailsImage is not null");
            return (Criteria) this;
        }

        public Criteria andDetailsimageEqualTo(String value) {
            addCriterion("detailsImage =", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageNotEqualTo(String value) {
            addCriterion("detailsImage <>", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageGreaterThan(String value) {
            addCriterion("detailsImage >", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageGreaterThanOrEqualTo(String value) {
            addCriterion("detailsImage >=", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageLessThan(String value) {
            addCriterion("detailsImage <", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageLessThanOrEqualTo(String value) {
            addCriterion("detailsImage <=", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageLike(String value) {
            addCriterion("detailsImage like", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageNotLike(String value) {
            addCriterion("detailsImage not like", value, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageIn(List<String> values) {
            addCriterion("detailsImage in", values, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageNotIn(List<String> values) {
            addCriterion("detailsImage not in", values, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageBetween(String value1, String value2) {
            addCriterion("detailsImage between", value1, value2, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andDetailsimageNotBetween(String value1, String value2) {
            addCriterion("detailsImage not between", value1, value2, "detailsimage");
            return (Criteria) this;
        }

        public Criteria andComshowidIsNull() {
            addCriterion("comShowId is null");
            return (Criteria) this;
        }

        public Criteria andComshowidIsNotNull() {
            addCriterion("comShowId is not null");
            return (Criteria) this;
        }

        public Criteria andComshowidEqualTo(Integer value) {
            addCriterion("comShowId =", value, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidNotEqualTo(Integer value) {
            addCriterion("comShowId <>", value, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidGreaterThan(Integer value) {
            addCriterion("comShowId >", value, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidGreaterThanOrEqualTo(Integer value) {
            addCriterion("comShowId >=", value, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidLessThan(Integer value) {
            addCriterion("comShowId <", value, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidLessThanOrEqualTo(Integer value) {
            addCriterion("comShowId <=", value, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidIn(List<Integer> values) {
            addCriterion("comShowId in", values, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidNotIn(List<Integer> values) {
            addCriterion("comShowId not in", values, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidBetween(Integer value1, Integer value2) {
            addCriterion("comShowId between", value1, value2, "comshowid");
            return (Criteria) this;
        }

        public Criteria andComshowidNotBetween(Integer value1, Integer value2) {
            addCriterion("comShowId not between", value1, value2, "comshowid");
            return (Criteria) this;
        }

        public Criteria andClassidIsNull() {
            addCriterion("ClassId is null");
            return (Criteria) this;
        }

        public Criteria andClassidIsNotNull() {
            addCriterion("ClassId is not null");
            return (Criteria) this;
        }

        public Criteria andClassidEqualTo(Integer value) {
            addCriterion("ClassId =", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotEqualTo(Integer value) {
            addCriterion("ClassId <>", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidGreaterThan(Integer value) {
            addCriterion("ClassId >", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("ClassId >=", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidLessThan(Integer value) {
            addCriterion("ClassId <", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidLessThanOrEqualTo(Integer value) {
            addCriterion("ClassId <=", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidIn(List<Integer> values) {
            addCriterion("ClassId in", values, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotIn(List<Integer> values) {
            addCriterion("ClassId not in", values, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidBetween(Integer value1, Integer value2) {
            addCriterion("ClassId between", value1, value2, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotBetween(Integer value1, Integer value2) {
            addCriterion("ClassId not between", value1, value2, "classid");
            return (Criteria) this;
        }

        public Criteria andStockdIsNull() {
            addCriterion("stockd is null");
            return (Criteria) this;
        }

        public Criteria andStockdIsNotNull() {
            addCriterion("stockd is not null");
            return (Criteria) this;
        }

        public Criteria andStockdEqualTo(Integer value) {
            addCriterion("stockd =", value, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdNotEqualTo(Integer value) {
            addCriterion("stockd <>", value, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdGreaterThan(Integer value) {
            addCriterion("stockd >", value, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdGreaterThanOrEqualTo(Integer value) {
            addCriterion("stockd >=", value, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdLessThan(Integer value) {
            addCriterion("stockd <", value, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdLessThanOrEqualTo(Integer value) {
            addCriterion("stockd <=", value, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdIn(List<Integer> values) {
            addCriterion("stockd in", values, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdNotIn(List<Integer> values) {
            addCriterion("stockd not in", values, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdBetween(Integer value1, Integer value2) {
            addCriterion("stockd between", value1, value2, "stockd");
            return (Criteria) this;
        }

        public Criteria andStockdNotBetween(Integer value1, Integer value2) {
            addCriterion("stockd not between", value1, value2, "stockd");
            return (Criteria) this;
        }

        public Criteria andInsertdateIsNull() {
            addCriterion("insertDate is null");
            return (Criteria) this;
        }

        public Criteria andInsertdateIsNotNull() {
            addCriterion("insertDate is not null");
            return (Criteria) this;
        }

        public Criteria andInsertdateEqualTo(Date value) {
            addCriterion("insertDate =", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateNotEqualTo(Date value) {
            addCriterion("insertDate <>", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateGreaterThan(Date value) {
            addCriterion("insertDate >", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateGreaterThanOrEqualTo(Date value) {
            addCriterion("insertDate >=", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateLessThan(Date value) {
            addCriterion("insertDate <", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateLessThanOrEqualTo(Date value) {
            addCriterion("insertDate <=", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateIn(List<Date> values) {
            addCriterion("insertDate in", values, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateNotIn(List<Date> values) {
            addCriterion("insertDate not in", values, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateBetween(Date value1, Date value2) {
            addCriterion("insertDate between", value1, value2, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateNotBetween(Date value1, Date value2) {
            addCriterion("insertDate not between", value1, value2, "insertdate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}